﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_InsertUserSessionLog')
	BEGIN
		DROP  Procedure  [esf_sso].P_InsertUserSessionLog
	END

GO

CREATE Procedure [esf_sso].P_InsertUserSessionLog
	@pID						UNIQUEIDENTIFIER
   ,@pUserPersonID				BIGINT
   ,@pStartDateTime				DATETIME
   ,@pUserHostAddress			VARCHAR (100)
   ,@pUserMachineIdentificator	VARCHAR (60)
AS

	INSERT INTO [esf_sso].[UserSessionLog]
       ([ID]
       ,[UserPersonID]
       ,[StartDateTime]
       ,[UserHostAddress]
       ,UserMachineIdentificator)
	VALUES
       (@pID
       ,@pUserPersonID
       ,@pStartDateTime
       ,@pUserHostAddress
       ,@pUserMachineIdentificator)
           
GO